
create external table jms_dm.dm_all_transfer_count_robot_sum_dt (
   taking_agent_code string comment '代理区code',
   taking_agent_name string comment '代理区名称',
   d_gh_zz_num_1 decimal(21,6) comment '日，t-1规划中转次数',
   d_sj_zz_num_1 decimal(21,6) comment '日，t-1实际中转次数',
   d_reback_zz_num_1 decimal(21,6) comment '日，t-1退件中转次数',
   d_reback_num_1 decimal(21,6) comment '日，t-1退件件量',
   d_rational_zz_num_1 decimal(21,6) comment '日，t-1不合理中转次数',
   d_rational_num_1 decimal(21,6) comment '日，t-1不合理中转件量',
   d_wrong_zz_num_1 decimal(21,6) comment '日，t-1网点错发中转次数',
   d_wrong_num_1 decimal(21,6) comment '日，t-1网点错发票数',
   d_bak_zz_num_1 decimal(21,6) comment '日，t-1备用路由中转次数',
   d_bak_num_1 decimal(21,6) comment '日，t-1备用路由中转件量',
   d_proble_zz_num_1 decimal(21,6) comment '日，t-1问题件中转次数',
   d_proble_num_1 decimal(21,6) comment '日，t-1问题件件量',
   d_gh_zz_num_2 decimal(21,6) comment '日，t-2规划中转次数',
   d_sj_zz_num_2 decimal(21,6) comment '日，t-2实际中转次数',
   d_reback_zz_num_2 decimal(21,6) comment '日，t-2退件中转次数',
   d_reback_num_2 decimal(21,6) comment '日，t-2退件件量',
   d_rational_zz_num_2 decimal(21,6) comment '日，t-2不合理中转次数',
   d_rational_num_2 decimal(21,6) comment '日，t-2不合理中转件量',
   d_wrong_zz_num_2 decimal(21,6) comment '日，t-2网点错发中转次数',
   d_wrong_num_2 decimal(21,6) comment '日，t-2网点错发票数',
   d_bak_zz_num_2 decimal(21,6) comment '日，t-2备用路由中转次数',
   d_bak_num_2 decimal(21,6) comment '日，t-2备用路由中转件量',
   d_proble_zz_num_2 decimal(21,6) comment '日，t-2问题件中转次数',
   d_proble_num_2 decimal(21,6) comment '日，t-2问题件件量',
   d_gh_zz_num_3 decimal(21,6) comment '日，t-3规划中转次数',
   d_sj_zz_num_3 decimal(21,6) comment '日，t-3实际中转次数',
   d_gh_zz_num_4 decimal(21,6) comment '日，t-4规划中转次数',
   d_sj_zz_num_4 decimal(21,6) comment '日，t-4实际中转次数',
   d_gh_zz_num_5 decimal(21,6) comment '日，t-5规划中转次数',
   d_sj_zz_num_5 decimal(21,6) comment '日，t-5实际中转次数',
   d_gh_zz_num_6 decimal(21,6) comment '日，t-6规划中转次数',
   d_sj_zz_num_6 decimal(21,6) comment '日，t-6实际中转次数',
   d_gh_zz_num_7 decimal(21,6) comment '日，t-7规划中转次数',
   d_sj_zz_num_7 decimal(21,6) comment '日，t-7实际中转次数',
   w_gh_zz_num_1 decimal(21,6) comment '周，t-1规划中转次数',
   w_sj_zz_num_1 decimal(21,6) comment '周，t-1实际中转次数',
   w_gh_zz_num_2 decimal(21,6) comment '周，t-2规划中转次数',
   w_sj_zz_num_2 decimal(21,6) comment '周，t-2实际中转次数',
   w_gh_zz_num_3 decimal(21,6) comment '周，t-3规划中转次数',
   w_sj_zz_num_3 decimal(21,6) comment '周，t-3实际中转次数',
   w_gh_zz_num_4 decimal(21,6) comment '周，t-4规划中转次数',
   w_sj_zz_num_4 decimal(21,6) comment '周，t-4实际中转次数',
   m_gh_zz_num_1 decimal(21,6) comment '月，t-1规划中转次数',
   m_sj_zz_num_1 decimal(21,6) comment '月，t-1实际中转次数',
   m_gh_zz_num_2 decimal(21,6) comment '月，t-2规划中转次数',
   m_sj_zz_num_2 decimal(21,6) comment '月，t-2实际中转次数',
   m_gh_zz_num_3 decimal(21,6) comment '月，t-3规划中转次数',
   m_sj_zz_num_3 decimal(21,6) comment '月，t-3实际中转次数',
   d_reback_zz_num_3 decimal(21,6) comment 't-3退件中转次数',
   d_reback_num_3 decimal(21,6) comment 't-3退件件量',
   d_rational_zz_num_3 decimal(21,6) comment 't-3不合理中转次数',
   d_rational_num_3 decimal(21,6) comment 't-3不合理中转件量',
   d_wrong_zz_num_3 decimal(21,6) comment 't-3网点错发中转次数',
   d_wrong_num_3 decimal(21,6) comment 't-3网点错发票数',
   d_bak_zz_num_3 decimal(21,6) comment 't-3备用路由中转次数',
   d_bak_num_3 decimal(21,6) comment 't-3备用路由中转件量',
   d_proble_zz_num_3 decimal(21,6) comment 't-3问题件中转次数',
   d_proble_num_3 decimal(21,6) comment 't-3问题件件量         ',
   d_reback_zz_num_4 decimal(21,6) comment 't-4退件中转次数',
   d_reback_num_4 decimal(21,6) comment 't-4退件件量',
   d_rational_zz_num_4 decimal(21,6) comment 't-4不合理中转次数',
   d_rational_num_4 decimal(21,6) comment 't-4不合理中转件量',
   d_wrong_zz_num_4 decimal(21,6) comment 't-4网点错发中转次数',
   d_wrong_num_4 decimal(21,6) comment 't-4网点错发票数',
   d_bak_zz_num_4 decimal(21,6) comment 't-4备用路由中转次数',
   d_bak_num_4 decimal(21,6) comment 't-4备用路由中转件量',
   d_proble_zz_num_4 decimal(21,6) comment 't-4问题件中转次数',
   d_proble_num_4 decimal(21,6) comment 't-4问题件件量     ',
   d_reback_zz_num_5 decimal(21,6) comment 't-5退件中转次数',
   d_reback_num_5 decimal(21,6) comment 't-5退件件量',
   d_rational_zz_num_5 decimal(21,6) comment 't-5不合理中转次数',
   d_rational_num_5 decimal(21,6) comment 't-5不合理中转件量',
   d_wrong_zz_num_5 decimal(21,6) comment 't-5网点错发中转次数',
   d_wrong_num_5 decimal(21,6) comment 't-5网点错发票数',
   d_bak_zz_num_5 decimal(21,6) comment 't-5备用路由中转次数',
   d_bak_num_5 decimal(21,6) comment 't-5备用路由中转件量',
   d_proble_zz_num_5 decimal(21,6) comment 't-5问题件中转次数',
   d_proble_num_5 decimal(21,6) comment 't-5问题件件量       ',
   d_reback_zz_num_6 decimal(21,6) comment 't-6退件中转次数',
   d_reback_num_6 decimal(21,6) comment 't-6退件件量',
   d_rational_zz_num_6 decimal(21,6) comment 't-6不合理中转次数',
   d_rational_num_6 decimal(21,6) comment 't-6不合理中转件量',
   d_wrong_zz_num_6 decimal(21,6) comment 't-6网点错发中转次数',
   d_wrong_num_6 decimal(21,6) comment 't-6网点错发票数',
   d_bak_zz_num_6 decimal(21,6) comment 't-6备用路由中转次数',
   d_bak_num_6 decimal(21,6) comment 't-6备用路由中转件量',
   d_proble_zz_num_6 decimal(21,6) comment 't-6问题件中转次数',
   d_proble_num_6 decimal(21,6) comment 't-6问题件件量        ',
   d_reback_zz_num_7 decimal(21,6) comment 't-7退件中转次数',
   d_reback_num_7 decimal(21,6) comment 't-7退件件量',
   d_rational_zz_num_7 decimal(21,6) comment 't-7不合理中转次数',
   d_rational_num_7 decimal(21,6) comment 't-7不合理中转件量',
   d_wrong_zz_num_7 decimal(21,6) comment 't-7网点错发中转次数',
   d_wrong_num_7 decimal(21,6) comment 't-7网点错发票数',
   d_bak_zz_num_7 decimal(21,6) comment 't-7备用路由中转次数',
   d_bak_num_7 decimal(21,6) comment 't-7备用路由中转件量',
   d_proble_zz_num_7 decimal(21,6) comment 't-7问题件中转次数',
   d_proble_num_7 decimal(21,6) comment 't-7问题件件量 ',
   date_time string comment ''
) COMMENT '全程中转次数机器人报表'
PARTITIONED BY (dt STRING COMMENT '')
STORED AS PARQUET
LOCATION '/dw/hive/jms_dm.db/external/dm_all_transfer_count_robot_sum_dt'
TBLPROPERTIES (
'discover.partitions'='false',
'parquet.column.index.access'='true'
);
